Copyright: Ezysheet Pty Ltd


Introduction

What is Ezysheet ?

It is a program which allows you to store table info safely (People often use Excel for this).

Basically, it consists of 2 screens:

- a BROWSE screen, which allows you to peruse your info safely.

- an UPDATE screen for when you want to update your info.

This is a different concept to Excel, which uses the one screen for these 2 quite distinct and different actions.

See the advantages of Ezysheet over Microsoft Excel.

Ezysheet is especially good for sports fixtures, as it allows the rows to be filtered by Team name.

For this to happen, you must have the 2 opposing teams defined as Home_Team  and Away_Team.

See the included sheet FIFA_WorldCup_2006 for an example.

We are very proud of this product; we believe that it is the best of its kind on the market. Contact us to find out why.

BROWSE screen

UPDATE screen

FAQs (Frequently Asked Questions)

Contact

Support

Suggestions / Improvements

Backups

                                       www.ezysheet.com

This help file was created with the free trial version of HelpScribble.


SETUP

Before you can start entering transactions into Ezysheet, some setup is necessary.

Please do the following in the order that they appear:

Company

On the toolbar at top, click Setup, then select "Company", then enter details.

The information in the box at the top of the screen must be filled out before you can subscribe.

This help file was created with the free trial version of HelpScribble.


FAQs (Frequently Asked Questions)

-------------------------------------------------------------------------------------------------

Question:-

Once I start using Ezysheet,

am I locked into using Ezysheet forever more ?

Answer:-

Not at all !

If you have a temporary moment of insanity :-)  and you want to use Microsoft Excel again,

simply click on the top Menu  File/Export  and you can save your sheet in a format that Microsoft Excel can understand.

Note that Microsoft Excel cannot handle pictures, so if you have these defined in your sheet, they cannot be exported.

-------------------------------------------------------------------------------------------------

Question:-

What if I want to have more than 1 sheet open at once ?

Answer:-

Just start another copy of Ezysheet running...

-------------------------------------------------------------------------------------------------

This help file was created with the free trial version of HelpScribble.


New Sheet

To create a new sheet...

- decide how many columns that you want in your sheet,

  and decide what TYPE (Text, Date, Number...) each column should be.

  If unsure what TYPE you want, make the column Text, as it is the most versatile.

- for each column that you want, type a row into the "Sheet Columns" grid.

  It is best to "tab to the right" when moving between cells in this grid.

- once you have finished adding the column definitions, check

  -  all the column names

  -  all the column TYPES

  -  all the SIZES if you have chosen a TYPE of TEXT

  -  the order of the columns (although of course, when viewing sheets, you can change the order of columns)

- Add a sheet description (bottom of screen), then click on the "Create Sheet" button.

Probably the easiest way to proceeed if you are new is to define some test sheets,

until you are comfortable with the process.

For example, maybe make up a shopping list, or a Movie list, or a Music CD list, or an Inventory.

Don't be timid; you cannot break anything !

How to find out the maximum number of characters in an Excel spreadsheet column

This help file was created with the free trial version of HelpScribble.


Advantages of Ezysheet over Microsoft Excel

The advantages that Ezysheet has over Microsoft Excel include the following:...

•	your info is SAFE

·	(can only insert,edit,delete ONE row at a time in Ezysheet;

 Microsoft Excel allows you to delete/corrupt your entire data with just 2 mouse clicks !!!)

•	you can easily sort your info on up to 12 columns

·	(Microsoft Excel has a maximum of 3 columns)

•	you can have pictures in each row

·	Microsoft Excel cannot do this

•	you can store fully formatted documents, as Ezysheet has its own word processor

·	unlike Microsoft Excel, which has extremely limited formatting

•	you can change the order of the columns

·	(just like Lotus Notes, Winzip, Microsoft Outlook, Explorer, and all other professional products)

•	it is much easier to use than a Microsoft Excel spreadsheet

·	(For example, - Easier to navigate to amongst the rows in a sheet

                            - Toolbar buttons, as well as having a picture, also have a description underneath)

This help file was created with the free trial version of HelpScribble.


Scrolling

This property controls the auto-repeat timing of the navigator.

When a user clicks a button and does not release the mouse, the navigator will re-execute the last clicked button after an initial delay.

 Thereafter it will continue to repeat the execution of the last clicked button until the button is released.

 For instance if the user presses the Next Record button and holds the mouse down,

 it will continually advance through the dataset until the mouse button is released.

This help file was created with the free trial version of HelpScribble.


Import

To import from a CSV file to a sheet...

- Make sure that you do not have the CSV file open anywhere (for example, in Microsoft Excel, MS Word, Notepad, etc...)

  If you do you may get an error message such as "I/O error 32".

- Make sure that you do not have the sheet open in the BROWSE/UPDATE screen of this Ezysheet program (or any other Ezysheet programs that are running)

- Click the SELECT CSV FILE button, and select the CSV file

- Click on the Radio button just below the SELECT CSV FILE button, to select the relevant CSV entry

- Click on the SELECT SHEET button, and select the sheet

- Click on the IMPORT button, and you will have imported the CSV file into the sheet.

-----------------------------------------------------------------------------------------------------------------------------

It is important to remember that the number of input fields in the CSV file should match the number in the sheet.

The only commas in the CSV file should be data separators; there should be no commas in the data fields.

So, when saving the CSV file from Microsoft Excel, do a FIND on ","  and remove any commas that you find before you create the CSV file.

This help file was created with the free trial version of HelpScribble.


How to find out the maximum number of characters in an Excel spreadsheet column

This is useful information when you are creating a sheet,

and you want to import a CSV file.

Note that CSV files can be viewed in Excel.

The maximum number of characters will give you an indication of how wide to make a TEXT column in a Sheet.

The steps to take are:

1) add an extra row at the top of the Excel sheet (for your formulas)

2)  type the following into the top row in each column

      =MAX(LEN(A3:A9))

      where A is the relevant column (change as required)

       and 3 is the first row of data (row 1 will contain your formula, row 2 the headings ) - YOU DO NOT NEED TO CHANGE THIS VALUE

       and 9 is the last row (change to the last row number in your sheet)

3) then press CTRL+SHIFT+ENTER when Cursor is in the FORMULA CELL above the sheet, and the row 3 cell is highlighted

See the following internet location for more discussion...

http://discuss.joelonsoftware.com/default.asp?design.4.395062.3

This help file was created with the free trial version of HelpScribble.


Backups

If you do not operate suitable backup procedures for your data you are running the risk of a total loss of records if your computer hard disk malfunctions or your computer is stolen.

A suitable backup procedure will minimise this risk.

It is prudent to keep your backup disk away from the location of your computer.

Above all else, it is critical that you maintain backups of your database that are both current and usable.

This means that you know that the copy that you are committing to tape, or to optical-disk, or to ZIP(TM) drives, is something that you could restore onto a completely empty computer and know that it will work.

Use only high quality media; do not use diskettes (floppies).

You are specifically warned that information in any computer database is both valuable and vulnerable !

There is no substitute for regular, complete, and known usable backups of your information.

No computer software tool can be guaranteed to recover information in any particular situation.

Responsibility for the safety and integrity of your data ultimately rests with YOU.

This help file was created with the free trial version of HelpScribble.


Suggestions / Improvements

If there are any program changes we could make such that:

- you would be convinced to use this program, or

- you think would improve the program

then please take the trouble to let us know.

Your feedback is always welcome.

mail@ezysheet.com

This help file was created with the free trial version of HelpScribble.


Licence Agreement

End user License Agreement for Ezysheet Software

Our software is protected by copyright and intellectual property laws and treaties.  Our software is licensed, not sold.  If our software is not transmitted electronically to you any media upon which it is encrypted for the purpose of transmission remains our property, is returnable at our request and does not  constitute part of the transaction between us.

A. GRANT OF LICENSE

Software.

You may install and use one copy of the software on a single computer.

B. DESCRIPTION OF OTHER RIGHTS AND LIMITATIONS

Limitations on reverse engineering, recompilation and disassembly.

You may not reverse engineer, decompile or disassemble the software, except and only to the extent that such activity is expressly permitted by applicable law.

Separation of Components.

This software is licensed as a single product.

Its components may not be separated for use on more than one computer.

Rental.

You may not rent or lease the software

Transfer.

You may permanently transfer all of your rights to this software, provided you retain no copies, you transfer all the software (including all component parts, the media and printed materials, any upgrades if the transferee to this license and subject to the limited warranties specified herein.

If the software is an upgrade, any transfer must include all prior versions of the software.

Termination.

Without prejudice to any other rights, Ezysheet may terminate this license if you fail to comply with the terms and conditions of this license.

In such event you must destroy all copies of the software and all of its component parts.

C. COPYRIGHT

All title and copyrights in and to the software (including any matters incorporated in the software), any accompanying printed material and any copies of the software are owned by Ezysheet or its suppliers.

The software is protected by copyright laws and international treaty provisions.

Therefore you must treat the software like any other copyright material except that you may either...

(a) make one copy of the software solely for backup or archival purposes, or

(b) install the software on a single computer provided you keep the original solely for backup or archival purposes.

You may not copy materials accompanying the software.

Limited warranty provision:

To the full extent permitted by the Commonwealth, State, Territory or other law or laws applicable any conditions or warranties imposed by legislation are hereby excluded.

Insofar as statute precludes such exclusion it is limited to:

1. Replacement of the software, or

2. Correction of the defects in the software

At the exclusive option of Ezysheet.

You acknowledge that no promise, representation or warranty or undertaking has been made or given by Ezysheet or any person or company on its behalf in relation to the profitability of or any other consequence or benefits to be obtained from delivery or use of the software or any matters ancillary thereto.

You have relied upon your own skills and judgement in deciding to purchase and accept that this is end-user license agreement is the whole of our agreement.

Save as herein provided, under no circumstances will Ezysheet be liable for any loss, damage or injury arising from the supply or use of the software and any related material or failure to perform an obligation or observe a term of our agreement.

This help file was created with the free trial version of HelpScribble.


BROWSE screen

There are various ways you can peruse your sheets...

To find out all the different things you can do to a column,

click on the blue sheet title row at the top of the sheet,

and a menu will appear.

F11 - Find First (Repeat)

F12 - Find Next (Repeat)

Move a Column

This is done by clicking on the blue Title row at the top of the Ezysheet, and then, while holding the mouse button down,

moving the Title bar column to left or right

Two little blue arrow heads will show you where the Column will go once you release the mouse button

View a single Row in its own separate window

Just double-click on the row that you want to view.

---------------------------------------------------------------------------------------------------------------------Pop up column MENU options follow:

Sort

You can sort...

- on one column at a time (both Ascending, and Descending), or

- many column at a time (can be a mixture of ascending/descending)

To sort on one column at a time you can either...

- click on the Title bar on the appropriate Column, and select from the pop up menu either "Sort Asc" or "Sort Desc", or...

- click on the "Single" sort button on the top of screen, and action as required from the pop up screen

To sort on many columns at a time you must...

- click on the "Many" sort button on the top of screen, and action as required from the pop up screen

Find (F11=First, F12=Next)

To find a value in a column you can either...

- click on the Title bar on the appropriate Column, and select FIND from the pop up menu, or...

- click on the "Find" button on the top of screen, and action as required from the pop up screen

You can only "Find" on one column at a time (this is the ONLY advantage that Excel has over Ezysheet)

Filter

Click on the blue column heading of the appropriate Column, and select the Filter option from the menu

Highlight

Click on the blue column heading of the appropriate Column, and select the Highlight option from the menu

This changes color in the selected Column when the Column value changes

This help file was created with the free trial version of HelpScribble.


UPDATE screen

F7  - Copy previous Column value..for Add/Edit

F8  - Copy entire previous Row....for Add/Edit

F11 - Find First (Repeat)

F12 - Find Next (Repeat)

Move a Column

This is done by clicking on the blue Title row at the top of the Ezysheet, and then, while holding the mouse button down,

moving the Title bar column to left or right

Two little blue arrow heads will show you where the Column will go once you release the mouse button

View a single Row in its own separate window

Just double-click on the row that you want to view.

---------------------------------------------------------------------------------------------------------------------Pop up column MENU options follow:

Find (F11=First, F12=Next)

To find a value in a column you can either...

- click on the Title bar on the appropriate Column, and select FIND from the pop up menu, or...

- click on the "Find" button on the top of screen, and action as required from the pop up screen

You can only "Find" on one column at a time (this is the ONLY advantage that Excel has over Ezysheet)

---------------------------------------------------------------------------------------------------------------------Problems

Sometimes when you click on a cell, the entire contents can seem to disappear (the cell looks empty),

or it may be that only the end of the cell data can be seen, or the cell contents may seem completely incorrect !

This can happen when you are cutting data from somewhere and pasting it into the sheet.

What you can inadvertently do is to copy an End-Of-Line character such that the cell contents wraps over 2 lines (or more).

To make sure that this is not happening, make the rows wider by positioning the cursor on the leftmost column (colored grey) at the bottom of a cell.

When the cursor changes to a pair of parallel lines with arrows, drag the cursor such that the row becomes wider.

Then you can see 2 or more lines within each cell.

This help file was created with the free trial version of HelpScribble.


Contact

EMAIL	mail@ezysheet.com

INTERNET	www.ezysheet.com

POST	P.O. Box 1135

DARLING VIC 3145

AUSTRALIA

This help file was created with the free trial version of HelpScribble.


Phone 0061 - 3 - 9885 - 7197

This help file was created with the free trial version of HelpScribble.


Support

Time permitting, we will solve any problems you may have installing or using Ezysheet:

Simply...

•	 EMAIL us at  mail@ezysheet.com

This help file was created with the free trial version of HelpScribble.


Other Toolbar buttons

This help file was created with the free trial version of HelpScribble.


 Setup - Company

This help file was created with the free trial version of HelpScribble.


HelpScribble
HelpScribble - The Complete Help Authoring Tool

This help file was created with the free evaluation version of HelpScribble.  This ad and the little footers below each topic will be automatically removed when the author recompiles this help file with the full version of HelpScribble. HelpScribble can be purchased securely online and is covered by a risk-free 90-day unconditional money-back guarantee.  See http://www.helpscribble.com/ for more information.

About HelpScribble

HelpScribble is a full-featured, easy-to-use help authoring tool for creating help files from start to finish.  You can create WinHelp (.hlp) files, HTML Help (.chm) files, a printed manual and online documentation (on a web site) all from the same HelpScribble project.

If you have previously used another help authoring tool, you can reuse your work by importing the HPJ+RTF files created with the other tool or by a decompiler.

You can use the help files you make with HelpScribble to provide context-sensitive help with your Window applications, no matter which development tool you use.  You can also use HelpScribble to create stand-alone portable documents.

Write Perfect Help Files for Your Software

You need HelpScribble to create a top quality help file for your software.  Windows users expect to receive detailed documentation at a quick press of the F1 button.  You will sell more copies of your software if a thoughtful help file flattens the learning curve for prospects trying the evaluation version of your product.

No matter which development tool you are using, you can always use a help file created with HelpScribble to provide context-sensitive help for your application.

If you know how to use a word processor, you can build a help file with HelpScribble.  Creating new topics and adding links to them cannot be easier.  No experience required.

Portable Documents with Hyperlinks

With HelpScribble you can easily create hyperlinked documents that can be read on any computer running Windows.

The WinHelp files that you create with HelpScribble are a collection of linked pages, just like a web site.  But unlike a web site, you only need to distribute one file.  This file can be read on any Windows computer.  No other software is needed.

You need absolutely no programming experience to use HelpScribble.  Many word processors and HTML editors are more complicated than HelpScribble.

The Complete Help Authoring Tool

HelpScribble is a full-featured stand-alone help authoring tool.  It is not an add-on for MS Word like so many other help writing products.  You can create the entire help file right within HelpScribble.

With HelpScribble you can even provide your documentation in several forms, all from the same source.  You can add context-sensitive help to your application, print a manual and provide online documentation on your web site.

WinHelp

WinHelp is the help file format supported by all versions of Windows.  It is fast, compact and supported by Windows 3.x, NT 3.x, 95, 98, ME, NT4, 2000 and XP.  All Windows users are familiar with it.  With any Windows development tool you can use WinHelp files to add context-sensitive help to your applications.

With HelpScribble you have all the functionality you need to build a complete help file, including table of contents, index, browse sequences, etc.  With HelpScribble's SHG (image map) editor, you can make your pictures (screen shots) say more than a thousand words.

Printed Manual

Reading from paper is a lot easier than reading from a screen.  A printed manual or, for downloadable software, a printable manual in PDF format, adds greatly to the value of your product.

You can use your HelpScribble project as the basis for your printed manual.  You can export your help text to one large RTF or HTML file that you or your DTP professional can turn into a finished manual using a word processor or DTP program.

HTML Help

With Windows 98, Microsoft introduced a new help file format called HTML Help.  Using HelpScribble, you can build classic WinHelp .hlp files and new HTML Help .chm files from the same source.  You decide whether you want maximum compatibility with older computers, or if you want to offer a state of the art help system.

Web Help

If you want to provide online documentation, you can create one large HTML file or a collection of HTML files from your HelpScribble project and upload those to your web site.  Your customers will have instant access to the latest documentation at any time.

Cross-Platform Help

If you are developing platforms such as Linux, where there is no standard help format, you can provide your documentation as HTML files.  The user can easily view those files in a browser.  If you use Kylix, you can even easily integrate them into your application.

Number 1 Help Tool for Delphi &amp; C++Builder

You can use HelpScribble no matter which development tool you use.  Even if you use no development tool at all.  (Stand-alone help files can be very useful.)  But if you are a Delphi or C++Builder developer, you will certainly appreciate the way HelpScribble integrates with your favorite development tool.

HelpScribble's HelpContext property editor takes most of the tedious job of assigning Topic IDs to HelpContext properties out of your hands.  Adding context-sensitive help to your application could not be easier.  Simply click on the corresponding controls and help topics to link them.

Delphi developers like HelpScribble so much that it won the Delphi Informant Readers Choice awards three years in a row.  In 1999, 2000 and 2001, HelpScribble was chosing the Best Help Authoring Package, beating well-known tools such as RoboHelp and ForeHelp.

Do Not Take My Word For It

I could rattle on all day about how great HelpScribble is.  But do not take my word for it!

Find out what the people say about HelpScribble before you decide to buy.

Chris Kryza "Just wanted to let you folks know that you have created a very, very, verynice product! The last time I had to generate a context sensitive help fileI used Doc-To-Help and I remember it took me weeks to get it right. WithHelpScribble I was able to put together a complete help system in under 2days and I then created a web-help deployment of same in seconds. I usedyour demo version to create the entire project and then purchased yourproduct online after I saw how good it all looked. Great stuff!"

Roj Ash "I just felt I had to compliment you on this product.  I have no experienceof producing Help files, and having evaluated a number of products, I wasbeginning to believe that a mere programmer had no chance whatever!

"I am not only making good progress in producing the Help for our product(which is usually used by **very** inexperienced users), but I'm actuallyenjoying it!

"Thanks for a great product."

Try the Free Evaluation Version Today

HelpScribble is an excellent help authoring tool.  But do not take my word for it!  Take a look at the self-running online demos or download the free evaluation version and see for yourself.  Convinced?  Buy HelpScribble now at http://www.helpscribble.com/